/***********************************************************
* Purpose : update the Category
* Author : TamNC
* Date: 19/1/2012
* Description: update the Category
*/
IF EXISTS ( SELECT * FROM SYSOBJECTS WHERE NAME = 'sp_UpdateCategory' ) 
BEGIN
	DROP PROC sp_UpdateCategory
END
GO
CREATE PROC sp_UpdateCategory
	@ID			int,
	@Name		NVARCHAR(50)
AS
BEGIN 
	DECLARE @Last_Update	DATETIME
	SET @Last_Update = GETDATE()
	UPDATE Category_Question 
	SET [Name] = @Name from Category_Question where ID=@ID
END 